All Questions
Tagged with xmlsql-server
6 questions
5votes
1answer
767views
Are legacy C# DataTable/SqlDataAdapters exponentially faster than SqlConnection/SqlCommand and/or LINQ to SQL DataContext.ExecuteCommand calls? [closed]
I can't believe DataTable/SqlDataAdapter massively beat out System.Data.Linq.DataContext.ExecuteCommand and ExecuteNonQuery (tried with both Stored Procedures and command text) and just straight ...
- 159
0votes
1answer
100views
Why storing a payroll in XML type field would be good or bad
We have a PAYROLL issues by the client to make it dynamic i.e. to make the whole process computerized. It includes: Employees Allowances (Scale wise, which could change yearly or monthly or anytime)...
1vote
1answer
234views
Design: Mixed XML / Relational or Pure Relational?
Is it acceptable to model a very complex object graph using XML in the database, but leave the rest of a system in relational tables? I'd like to gauge opinion on this as I've hit a bit of a ...
0votes
3answers
1kviews
Using xml datatype to store a "shopping cart"
For my final project in school we have to develop an online shop. This shop should have a cart where items can be placed whether or not you are logged in. If you log out the cart shouldn't empty and ...
1vote
2answers
2kviews
Which database to prefer while developing a WPF medical inventory system?
I have a project to develop an inventory system for a medical shop. Till date, I confronted simple requirements which were fulfilled with XML as the backend db. My interaction knowledge with XML is ...
- 5,080
15votes
7answers
22kviews
When should I use the XML data type in SQL Server?
When should I use the XML data type in Microsoft SQL Server?
